
module.exports = {
	assistType:{
		building:'building_type',
		credit:'credit_ask',
		lendingAsk:'lending_ask',
		lendingType:'lending_type',
		loan:'loan_type',
		noteAffair:'note_affair',
		trade:'trade_type',
		repayment:'repayment',
		interest:'default_interest',
		loanCharge:'loan_charge',
		datum:'datum',
		debtAsk:'debt_ask',
		safeWork:'safe_work',
		socialAsk:'social_ask'
	},
	queryAssistAll:function(name){
		return 'SELECT * FROM '+this.assistType[name]+'';
	},
	removeAssist:function(id,name){
		return 'DELETE FROM ' + this.assistType[name] + ' WHERE ID = ' + id;
	},
	updateAssist:function(param){
		return 'UPDATE ' + this.assistType[param.name] + ' SET CONTENT="'+param.content+'" WHERE ID='+param.id;
	},
	addAssist:function(param){
		return 'INSERT INTO ' + this.assistType[param.name] +'(CONTENT) VALUES("'+param.content+'")';
	}
};